package com.wclass.mapper;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.wclass.entity.BaseTeamUser;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 团队介绍-主要成员 Mapper 接口
 * </p>
 *
 * @author SEN
 * @since 2019-02-14
 */
public interface BaseTeamUserMapper extends BaseMapper<BaseTeamUser> {

    @Select("select tu.*,au.picture_address as pic_url,au.nick_name as name,au.personal_intro as intro,au.phone " +
            "from base_team_user tu left join base_app_user au on tu.user_id = au.id " +
            "where 1=1 ${ew.sqlSegment}")
    List<BaseTeamUser> selectTeamUserInfo(@Param("ew") EntityWrapper<BaseTeamUser> ew);

}
